Tabela InvoiceData

Definicja tabeli InvoiceData

Name

InvoiceData

Code

InvoiceData

Comment

 


Lista kolumn tabeli InvoiceData

Name

Code

InvoiceDataID

InvoiceDataID

ContractorCountry

ContractorCountry

ContractorFax

ContractorFax

ContractorName

ContractorName

ContractorPhone

ContractorPhone

ContractorPostOffice

ContractorPostOffice

ContractorPlace

ContractorPlace

ContractorStreet

ContractorStreet

ContractorTaxPayerID

ContractorTaxPayerID

PaymentType

PaymentType

Seller1Country

Seller1Country

Seller1Fax

Seller1Fax

Seller1Name

Seller1Name

Seller1Phone

Seller1Phone

Seller1Place

Seller1Place

Seller1PostOffice

Seller1PostOffice

Seller1Street

Seller1Street

Seller1TaxPayerID

Seller1TaxPayerID

ContractorStadCode

ContractorStadCode

Seller1StadCode

Seller1StadCode

ContractorStatisticalCompanyNo

ContractorStatisticalCompanyNo

Seller1StatisticalCompanyNo

Seller1StatisticalCompanyNo

ContractorCode

ContractorCode

Seller1Code

Seller1Code

InvoiceFK

InvoiceFK

BankName

BankName

ContractorZipPostalCode

ContractorZipPostalCode

SellerZipPostalCode

SellerZipPostalCode

BankAccount

BankAccount


Kolumna InvoiceDataID tabeli InvoiceData

Definicja kolumny InvoiceDataID tabeli InvoiceData

Name

InvoiceDataID

Code

InvoiceDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractorCountry tabeli InvoiceData

Definicja kolumny ContractorCountry tabeli InvoiceData

Name

ContractorCountry

Code

ContractorCountry

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna ContractorFax tabeli InvoiceData

Definicja kolumny ContractorFax tabeli InvoiceData

Name

ContractorFax

Code

ContractorFax

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna ContractorName tabeli InvoiceData

Definicja kolumny ContractorName tabeli InvoiceData

Name

ContractorName

Code

ContractorName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ContractorPhone tabeli InvoiceData

Definicja kolumny ContractorPhone tabeli InvoiceData

Name

ContractorPhone

Code

ContractorPhone

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna ContractorPostOffice tabeli InvoiceData

Definicja kolumny ContractorPostOffice tabeli InvoiceData

Name

ContractorPostOffice

Code

ContractorPostOffice

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna ContractorPlace tabeli InvoiceData

Definicja kolumny ContractorPlace tabeli InvoiceData

Name

ContractorPlace

Code

ContractorPlace

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna ContractorStreet tabeli InvoiceData

Definicja kolumny ContractorStreet tabeli InvoiceData

Name

ContractorStreet

Code

ContractorStreet

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna ContractorTaxPayerID tabeli InvoiceData

Definicja kolumny ContractorTaxPayerID tabeli InvoiceData

Name

ContractorTaxPayerID

Code

ContractorTaxPayerID

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna PaymentType tabeli InvoiceData

Definicja kolumny PaymentType tabeli InvoiceData

Name

PaymentType

Code

PaymentType

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna Seller1Country tabeli InvoiceData

Definicja kolumny Seller1Country tabeli InvoiceData

Name

Seller1Country

Code

Seller1Country

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1Fax tabeli InvoiceData

Definicja kolumny Seller1Fax tabeli InvoiceData

Name

Seller1Fax

Code

Seller1Fax

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1Name tabeli InvoiceData

Definicja kolumny Seller1Name tabeli InvoiceData

Name

Seller1Name

Code

Seller1Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Seller1Phone tabeli InvoiceData

Definicja kolumny Seller1Phone tabeli InvoiceData

Name

Seller1Phone

Code

Seller1Phone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1Place tabeli InvoiceData

Definicja kolumny Seller1Place tabeli InvoiceData

Name

Seller1Place

Code

Seller1Place

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Seller1PostOffice tabeli InvoiceData

Definicja kolumny Seller1PostOffice tabeli InvoiceData

Name

Seller1PostOffice

Code

Seller1PostOffice

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1Street tabeli InvoiceData

Definicja kolumny Seller1Street tabeli InvoiceData

Name

Seller1Street

Code

Seller1Street

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Seller1TaxPayerID tabeli InvoiceData

Definicja kolumny Seller1TaxPayerID tabeli InvoiceData

Name

Seller1TaxPayerID

Code

Seller1TaxPayerID

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna ContractorStadCode tabeli InvoiceData

Definicja kolumny ContractorStadCode tabeli InvoiceData

Name

ContractorStadCode

Code

ContractorStadCode

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1StadCode tabeli InvoiceData

Definicja kolumny Seller1StadCode tabeli InvoiceData

Name

Seller1StadCode

Code

Seller1StadCode

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna ContractorStatisticalCompanyNo tabeli InvoiceData

Definicja kolumny ContractorStatisticalCompanyNo tabeli InvoiceData

Name

ContractorStatisticalCompanyNo

Code

ContractorStatisticalCompanyNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna Seller1StatisticalCompanyNo tabeli InvoiceData

Definicja kolumny Seller1StatisticalCompanyNo tabeli InvoiceData

Name

Seller1StatisticalCompanyNo

Code

Seller1StatisticalCompanyNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna ContractorCode tabeli InvoiceData

Definicja kolumny ContractorCode tabeli InvoiceData

Name

ContractorCode

Code

ContractorCode

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Seller1Code tabeli InvoiceData

Definicja kolumny Seller1Code tabeli InvoiceData

Name

Seller1Code

Code

Seller1Code

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna InvoiceFK tabeli InvoiceData

Definicja kolumny InvoiceFK tabeli InvoiceData

Name

InvoiceFK

Code

InvoiceFK

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna BankName tabeli InvoiceData

Definicja kolumny BankName tabeli InvoiceData

Name

BankName

Code

BankName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna ContractorZipPostalCode tabeli InvoiceData

Definicja kolumny ContractorZipPostalCode tabeli InvoiceData

Name

ContractorZipPostalCode

Code

ContractorZipPostalCode

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna SellerZipPostalCode tabeli InvoiceData

Definicja kolumny SellerZipPostalCode tabeli InvoiceData

Name

SellerZipPostalCode

Code

SellerZipPostalCode

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna BankAccount tabeli InvoiceData

Definicja kolumny BankAccount tabeli InvoiceData

Name

BankAccount

Code

BankAccount

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Lista kluczy tabeli InvoiceData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli InvoiceData

Definicja klucza Identifier_1 tabeli InvoiceData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment